Ì i 2
add.earn.ont.vac.temp
*(JY)JYZZO
Field Name Len Dat Typ J DPM Offset/Local/VAL
add.earn.ont.from 8 DATE L *(JY)JYZZO|0
add.earn.ont.payroll 8 FREE L PP.PAYROLL *(JY)JYZZO|2
add.earn.ont.stars 1 FREE L *(JY)JYZZO|3
add.earn.ont.thru 8 DATE L *(JY)JYZZO|1
Ì € i 2
add.earn.ont.amounts
[add.earn.ont.employee]
*(JY)JYZZO["A",jy]
Field Name Len Dat Typ J DPM Offset/Local/VAL
add.earn.ont.employee 42 URN L PP.PER jy
add.earn.ont.acc 8 SMONEY R *(JY)JYZZO["A",jy]|2
add.earn.ont.due 8 SMONEY R *(JY)JYZZO["A",jy]|3
add.earn.ont.min 8 SMONEY R *(JY)JYZZO["A",jy]|0
add.earn.ont.rec 8 SMONEY R *(JY)JYZZO["A",jy]|1
add.earn.ont.star 1 FREE L *(JY)JYZZO["A",jy]|4
Ì i 2
add.xfer.errors
[add.xfer.err.ret.urn]
*(JY)JYWWE[jzr]
Field Name Len Dat Typ J DPM Offset/Local/VAL
add.xfer.err.ret.urn 5 INT R jzr
Ì € i 2
add.xfer.error
[add.xfer.err.ret.urn, add.xfer.err.name,add.xfer.err.urn]
*(JY)JYWWE[jzr]E[jySN,jy]
Field Name Len Dat Typ J DPM Offset/Local/VAL
add.xfer.err.name 26 FREE L jySN
add.xfer.err.urn 42 URN L PP.PER jy
add.xfer.err.reason 48 FREE L *(JY)JYWWE[jzr]E[jySN,jy]|0
Ì i 2
additional.earnings
[add.earn.employee,add.earning]
*(JY)JYZZ[jy,jde]
Field Name Len Dat Typ J DPM Offset/Local/VAL
add.earn.employee 42 URN L PP.PER jy
add.earning 8 PDEC L PP.EARN jde
add.earn.amount 8 SMONEY R *(JY)JYZZ[jy,jde]
add.earn.with.reg.whld 1 YN L *(JY)JYZZ[jy,jde]ORD|0
Ì i 2
additional.wholdings
[add.whold.employee,add.wholding]
*(JY)JYWW[jy,jdw]
Field Name Len Dat Typ J DPM Offset/Local/VAL
add.whold.employee 42 URN L PP.PER jy
add.wholding 8 PDEC L PP.WHOLD jdw
add.whld.with.reg.whld 1 YN L *(JY)JYWW[jy,jdw]ORD|0
add.whold.ee.amount 8 SMONEY R *(JY)JYWW[jy,jdw]|0
add.whold.er.amount 8 SMONEY R *(JY)JYWW[jy,jdw]|1
Ì i 2
benefit.adjustments
[ben.adj.date,ben.adj.payroll,ben.adj.employee,ben.adj.account]
*(JY)JYGL[jyGD,jdp,jy,ga]
Field Name Len Dat Typ J DPM Offset/Local/VAL
ben.adj.date 8 DATE L jyGD
ben.adj.payroll 8 FREE L PP.PAYROLL jdp
ben.adj.employee 42 URN L PP.PER jy
ben.adj.account 25 FREE L MIS.GL.ACCOUNT ga
ben.adj.cr 10 MONEY R *(JY)JYGL[jyGD,jdp,jy,ga]|1
ben.adj.dr 10 MONEY R *(JY)JYGL[jyGD,jdp,jy,ga]|0
ben.adj.hrs 8 SDEC3 R *(JY)JYGL[jyGD,jdp,jy,ga]|2
Ì i 2
expense.to.periods
[exp.activity.date]
*(JY)JYGLD[jyGLD]
Field Name Len Dat Typ J DPM Offset/Local/VAL
exp.activity.date 8 DATE L jyGLD
exp.for.gl.period 8 DATE L *(JY)JYGLD[jyGLD]
Ì i 2
input.eff.base.rates
[in.employee, in.eff.date]
/JY[jy]13[jefd]
Field Name Len Dat Typ J DPM Offset/Local/VAL
in.eff.date 8 DATE L jefd
in.eff.rate 8 RATE R /JY[jy]13[jefd]|1
in.eff.reason 10 FREE L PP.REASON /JY[jy]13[jefd]|2
in.eff.step 2 PINT L /JY[jy]13[jefd]|0
Ì i 2
input.sec.eff.rates
[in.employee,in.sec.job.counter, in.sec.eff.date]
/JY[jy]SJ[jySC]SR[jefd]
Field Name Len Dat Typ J DPM Offset/Local/VAL
in.sec.eff.date 8 DATE L jefd
in.sec.eff.rate 8 RATE R /JY[jy]SJ[jySC]SR[jefd]|1
in.sec.eff.step 2 PINT L /JY[jy]SJ[jySC]SR[jefd]|0
Ì € i 2
main
[employee]
$(JY)JY[jy]
Field Name Len Dat Typ J DPM Offset/Local/VAL
employee 42 URN L jy
activity.date 8 DATE L VAL=@.today
addr1 26 FREE L $(JY)JY[jy]|5
addr2 26 FREE L $(JY)JY[jy]|6
addr3 26 FREE L $(JY)JY[jy]|7
address1 30 FREE L $(JY)JY[jy]0|0
address2 30 FREE L $(JY)JY[jy]0|1
adj.hire.month.alpha 3 FREE L VAL=IF{@PP.PER.adjusted.hire.date "JANFEBMARAPRMAYJUNJ
VAL=ULAUGSEPOCTNOVDEC"'$((@PP.PER.adj.hire.month.numer
VAL=ic)-1*3)$3}
adj.hire.month.numeric 2 PINT R VAL=(@PP.PER.adjusted.hire.date%3$2)
adjusted.hire.date 8 DATE L $(JY)JY[jy]1|12
base.rate 8 RATE R $(JY)JY[jy]7|7
base.rate.date 8 DATE L $(JY)JY[jy]7|9
base.rate.reason 10 FREE L PP.REASON $(JY)JY[jy]7|8
being.paid 1 YN L $(JY)JY[jy]1|10
benefit.contr.hours 10 SDEC3 R $(JY)JY[jy]1|18
benefit.contr.hours.sort 10 SDEC3 R VAL=(1000000-@benefit.contr.hours:3D)
cd.screen.1 15 FREE L MIS.SCREEN VAL=@PP.TYPE.customer.def.screen[@empl.type]
cd.screen.2 15 FREE L MIS.SCREEN VAL=@PP.PAYROLL.customer.def.screen[@payroll]
cd.screen.3 15 FREE L MIS.SCREEN VAL=@PP.TYPE.customer.def.screen.2[@empl.type]
city 18 FREE L $(JY)JY[jy]0|2
cobra.number 42 URN L PP.PER.COBRA $(JY)JY[jy]M1|6
contract 8 FREE L PP.CONTRACT $(JY)JY[jy]1|17
date.of.birth 10 BDATE L $(JY)JY[jy]|11
dd.account.number 17 FREE L $(JY)JY[jy]7|13
dd.account.type 1 CHOICE L $(JY)JY[jy]7|14
dd.bank 17 FREE L PP.BANK $(JY)JY[jy]7|12
dd.notification.account 17 FREE L $(JY)JY[jy]7|16
dd.notification.bank 17 FREE L PP.BANK $(JY)JY[jy]7|15
dd.notification.date 8 DATE L $(JY)JY[jy]7|18
dd.notification.type 1 CHOICE L $(JY)JY[jy]7|17
dd.proration.method 1 CHOICE L $(JY)JY[jy]7|25
de6.wage.plan 1 CHOICE L $(JY)JY[jy]|17
deceased 1 YN L $(JY)JY[jy]7|23
dept 15 FREE L MIS.GL.DEPT $(JY)JY[jy]1|3
dept.access.ok 1 FREE L VAL=%MIS.GL.DEPT.user.ok(@PP.PER.dept)
disability 1 YN L $(JY)JY[jy]M1|0
eeoc 18 CHOICE L $(JY)JY[jy]|13
email.addr 40 FREE L $(JY)JY[jy]M1|9
emergency.phone 18 PHONE L $(JY)JY[jy]|10
emp.user.mnemonic 10 FREE L MIS.USER $(JY)JY[jy]M1|12
empl.type 5 FREE L PP.TYPE $(JY)JY[jy]1|0
empl.type.date 8 DATE L $(JY)JY[jy]1|22
employee.picture 1 BMP L VAL=^@Appl.file.prefix(PP,PICRAD)[@PP.PER.picture.fold
VAL=er_.._PP.PER.employee_".JPG"]
evaluation.date 8 DATE L $(JY)JY[jy]1|16
exclude.from.de6 1 YN L $(JY)JY[jy]|16
exempt 1 YN L $(JY)JY[jy]7|5
fit.exemptions 2 INT L $(JY)JY[jy]7|4
fit.tax.status 1 CHOICE L $(JY)JY[jy]7|3
flsa.per.week.calc 1 YN L $(JY)JY[jy]|15
fmla.start 4 INT R $(JY)JY[jy]M1|13
health.insurance 1 YN L $(JY)JY[jy]M1|3
hire.date 8 DATE L $(JY)JY[jy]1|11
hire.month.alpha 3 FREE L VAL=IF{@PP.PER.hire.date "JANFEBMARAPRMAYJUNJULAUGSEPO
VAL=CTNOVDEC"'$((@PP.PER.hire.month.numeric)-1*3)$3}
hire.month.numeric 2 PINT R VAL=(@PP.PER.hire.date%3$2)
home.phone 18 PHONE L $(JY)JY[jy]|9
hours.per.period 6 DEC3 R $(JY)JY[jy]1|6
hrs.per.period.date 8 DATE L $(JY)JY[jy]1|23
incomplete.pay.fields 1 YN L $(JY)JY[jy]7|19
insurance.coverage 40 FREE L $(JY)JY[jy]7|20
job.code 10 FREE L PP.JOB $(JY)JY[jy]1|2
marital.status 10 FREE L MIS.MAR.STATUS $(JY)JY[jy]M1|4
marital.status.date 8 DATE L $(JY)JY[jy]M1|5
medicare.date 8 DATE L $(JY)JY[jy]M1|2
month.and.day.of.birth 4 PINT R VAL=(@date.of.birth%3)
monthly.salary 8 MONEY R VAL=%PP.PER.monthly.salary(PP.PER.employee)
name 26 NAME L $(JY)JY[jy]|2
next.review.date 8 DATE L $(JY)JY[jy]1|13
next.review.reason 10 FREE L PP.REASON $(JY)JY[jy]1|14
number 14 FREE L $(JY)JY[jy]|4
ont.vac.calc.thru 8 DATE L $(JY)JY[jy]7|22
other.country 10 FREE L $(JY)JY[jy]0|6
other.country.choice 6 CHOICE L $(JY)JY[jy]0|5
outside.agency 1 YN L $(JY)JY[jy]|14
payroll 8 FREE L PP.PAYROLL $(JY)JY[jy]7|0
pension 1 YN L $(JY)JY[jy]7|24
picture.aspect 3 FREE L $(JY)JY[jy]M1|14
picture.date 8 DATE L $(JY)JY[jy]M1|8
picture.folder 4 FREE L $(JY)JY[jy]M1|7
pop.grp 8 FREE L PP.POPUL $(JY)JY[jy]M1|1
position.date 8 DATE L $(JY)JY[jy]1|24
position.number 18 FREE L PP.POS $(JY)JY[jy]1|1
postal.code 10 FREE L $(JY)JY[jy]0|4
print.cd.screen.1 0 FREE L VAL=IF{@cd.screen.1 %MIS.SCREEN.print(@cd.screen.1,^@c
VAL=ustomer.defined.fields,"",3),""}
print.cd.screen.2 0 FREE L VAL=IF{@cd.screen.2 %MIS.SCREEN.print(@cd.screen.2,^@c
VAL=ustomer.defined.fields,"",3),""}
print.cd.screen.3 0 FREE L VAL=IF{@cd.screen.3 %MIS.SCREEN.print(@cd.screen.3,^@c
VAL=ustomer.defined.fields,"",3),""}
print.cd.screen.verbatm.1 0 FREE L VAL=IF{@cd.screen.1 %MIS.SCREEN.print(@cd.screen.1,^@c
VAL=ustomer.defined.fields,1,0),""}
print.cd.screen.verbatm.2 0 FREE L VAL=IF{@cd.screen.2 %MIS.SCREEN.print(@cd.screen.2,^@c
VAL=ustomer.defined.fields,1,0),""}
print.cd.screen.verbatm.3 0 FREE L VAL=IF{@cd.screen.3 %MIS.SCREEN.print(@cd.screen.3,^@c
VAL=ustomer.defined.fields,1,0),""}
qual.diff 8 RATE R $(JY)JY[jy]7|11
reserved.position 18 FREE L PP.POS $(JY)JY[jy]1|25
review.contr.hours 10 SDEC3 R $(JY)JY[jy]1|19
review.contr.hours.sort 10 SDEC3 R VAL=(1000000-@review.contr.hours:3D)
roe.date 8 DATE L $(JY)JY[jy]1|21
seniority.date 8 DATE L $(JY)JY[jy]1|15
sex 1 CHOICE L $(JY)JY[jy]|12
shift 1 PINT L $(JY)JY[jy]1|4
shift.date 8 DATE L $(JY)JY[jy]1|5
shift.diff.amount 8 RATE R VAL=%PP.PER.diff.amount(employee)
si.number 12 FREE L $(JY)JY[jy]|1
si.number.govt 11 FREE L VAL=(@PP.PER.si.number$11)
sit.exemptions 2 INT L $(JY)JY[jy]7|2
sit.tax.status 1 CHOICE L $(JY)JY[jy]7|1
sort.base.rate 8 RATE R VAL=(10000-@base.rate)
sort.name 26 NAME L $(JY)JY[jy]|3
ss.number 12 FREE L $(JY)JY[jy]|1
ss.number.govt 11 FREE L VAL=(@PP.PER.ss.number$11)
state 2 FREE L $(JY)JY[jy]0|3
status 7 CHOICE L $(JY)JY[jy]1|7
status.date 8 DATE L $(JY)JY[jy]1|8
status.reason 10 FREE L PP.REASON $(JY)JY[jy]1|9
statutory 1 YN L $(JY)JY[jy]7|26
step 2 PINT L $(JY)JY[jy]7|6
step.grade.base.hi 8 PDEC R VAL=%PP.PER.step.grade.base(employee,"HI")
step.grade.base.lo 8 PDEC R VAL=%PP.PER.step.grade.base(employee,"LO")
t4.country 10 FREE L $(JY)JY[jy]6|3
t4.country.choice 5 CHOICE L $(JY)JY[jy]6|2
t4.cpp.qpp.exempt 1 YN L $(JY)JY[jy]6|0
t4.ei.exempt 1 YN L $(JY)JY[jy]6|1
t4.employment.code 2 CHOICE L $(JY)JY[jy]6|4
t4.stock.code 2 CHOICE L $(JY)JY[jy]6|5
tax.year 4 YEAR L $(JY)JY[jy]7|21
tc.hours.pro.elig 1 YN L $(JY)JY[jy]M1|10
tc.hours.pro.pri.pct 6 DEC3 R $(JY)JY[jy]M1|11
td1.exemption 8 MONEY R $(JY)JY[jy]7|10
td1.exemption.prov 8 MONEY R $(JY)JY[jy]7|27
yearly.salary 9 MONEY R VAL=%PP.PER.yearly.salary(PP.PER.employee)
Ì € i 2
benefit.balances
[employee, benefit]
$(JY)JY[jy]9[jde]
Field Name Len Dat Typ J DPM Offset/Local/VAL
benefit 8 PDEC L PP.EARN jde
benefit.accrued.balance 9 SDEC3 R $(JY)JY[jy]9[jde]|3
benefit.avail.balance 9 SDEC3 R $(JY)JY[jy]9[jde]|2
benefit.edit.reason 10 FREE L PP.REASON $(JY)JY[jy]9[jde]|8
benefit.freeze 1 YN L $(JY)JY[jy]9[jde]|5
benefit.freeze.contr.hrs 8 DEC3 R $(JY)JY[jy]9[jde]|7
benefit.freeze.date 8 DATE L $(JY)JY[jy]9[jde]|6
benefit.occurance 3 PINT R $(JY)JY[jy]9[jde]|9
benefit.occurance.yr 4 YEAR L $(JY)JY[jy]9[jde]|10
benefit.plan 8 FREE L $(JY)JY[jy]9[jde]|1
benefit.update.gl 1 YN L $(JY)JY[jy]9[jde]|4
Ì € i 2
customer.defined.queries
[employee, cd.query]
$(JY)JY[jy]CD[ggv]
Field Name Len Dat Typ J DPM Offset/Local/VAL
cd.query 10 FREE L MIS.QUERY ggv
cd.response 75 QRY.RESP L $(JY)JY[jy]CD[ggv]|0
cd.yn.comment 75 FREE L $(JY)JY[jy]CD[ggv]|5
Ì € i 2
customer.def.mult.queries
[employee,cd.query, cdm.seq.no]
$(JY)JY[jy]CD[ggv]M[ggvN]
Field Name Len Dat Typ J DPM Offset/Local/VAL
cdm.seq.no 3 PINT R ggvN
cdm.response 75 QRY.RESP L $(JY)JY[jy]CD[ggv]M[ggvN]|0
Ì € i 2
dd.proration
[employee, dd.pro.counter]
$(JY)JY[jy]2[mpC]
Field Name Len Dat Typ J DPM Offset/Local/VAL
dd.pro.counter 2 INT R mpC
dd.pro.account.number 17 FREE L $(JY)JY[jy]2[mpC]|2
dd.pro.account.type 1 CHOICE L $(JY)JY[jy]2[mpC]|3
dd.pro.bank 17 FREE L PP.BANK $(JY)JY[jy]2[mpC]|1
dd.pro.note.account 17 FREE L $(JY)JY[jy]2[mpC]|6
dd.pro.note.bank 17 FREE L PP.BANK $(JY)JY[jy]2[mpC]|5
dd.pro.note.date 8 DATE L $(JY)JY[jy]2[mpC]|8
dd.pro.note.type 1 CHOICE L $(JY)JY[jy]2[mpC]|7
dd.pro.type 7 CHOICE L $(JY)JY[jy]2[mpC]|0
dd.pro.value 10 FREE L $(JY)JY[jy]2[mpC]|4
Ì € i 2
dependents
[employee, dp.number]
$(JY)JY[jy]DP[jyDP]
Field Name Len Dat Typ J DPM Offset/Local/VAL
dp.number 2 PINT R jyDP
dp.active 1 YN L $(JY)JY[jy]DP[jyDP]|5
dp.address1 30 FREE L $(JY)JY[jy]DP[jyDP]0|0
dp.address2 30 FREE L $(JY)JY[jy]DP[jyDP]0|1
dp.age 3 PINT R VAL=%Z.age(@dp.birthdate,@.today)^XX$L(XX,"Y")?0N!0
dp.birthdate 10 BDATE L $(JY)JY[jy]DP[jyDP]|1
dp.city 18 FREE L $(JY)JY[jy]DP[jyDP]0|2
dp.cobra.number 42 URN L PP.PER.COBRA $(JY)JY[jy]DP[jyDP]|11
dp.desc 23 FREE L VAL=@MIS.RELAT.name[@dp.relationship]$23
dp.email.addr 40 FREE L $(JY)JY[jy]DP[jyDP]|14
dp.emergency.phone 18 PHONE L $(JY)JY[jy]DP[jyDP]|8
dp.home.phone 18 PHONE L $(JY)JY[jy]DP[jyDP]|7
dp.marital.status 10 FREE L MIS.MAR.STATUS $(JY)JY[jy]DP[jyDP]|9
dp.marital.status.date 8 DATE L $(JY)JY[jy]DP[jyDP]|10
dp.medicare.date 8 DATE L $(JY)JY[jy]DP[jyDP]|12
dp.name 26 NAME L $(JY)JY[jy]DP[jyDP]|0
dp.other.country 10 FREE L $(JY)JY[jy]DP[jyDP]0|6
dp.other.country.choice 6 CHOICE L $(JY)JY[jy]DP[jyDP]0|5
dp.postal.code 10 FREE L $(JY)JY[jy]DP[jyDP]0|4
dp.relationship 10 FREE L MIS.RELAT $(JY)JY[jy]DP[jyDP]|2
dp.si.number 12 FREE L $(JY)JY[jy]DP[jyDP]|3
dp.sort.name 26 NAME L $(JY)JY[jy]DP[jyDP]|4
dp.ss.number 12 FREE L $(JY)JY[jy]DP[jyDP]|3
dp.state 2 FREE L $(JY)JY[jy]DP[jyDP]0|3
dp.student 1 YN L VAL=IF{@dp.student.thru.date<@.today "N";"Y"}
dp.student.thru.date 8 DATE L $(JY)JY[jy]DP[jyDP]|6
dp.text.edit 1 YN L $(JY)JY[jy]DP[jyDP]|13
Ì € i 2
dependent.comments
[employee,dp.number, dp.text.q]
$(JY)JY[jy]DP[jyDP]C[jyDPC]
Field Name Len Dat Typ J DPM Offset/Local/VAL
dp.text.q 8 PINT R jyDPC
dp.text.line 92 TEXT L $(JY)JY[jy]DP[jyDP]C[jyDPC]
Ì € i 2
earnings
[employee, earning.counter]
$(JY)JY[jy]E[jyEC]
Field Name Len Dat Typ J DPM Offset/Local/VAL
earning.counter 2 INT R jyEC
earning 8 PDEC L PP.EARN $(JY)JY[jy]E[jyEC]|0
earning.active 1 YN L $(JY)JY[jy]E[jyEC]|1
earning.created.by.flex 1 YN L $(JY)JY[jy]E[jyEC]|4
earning.expression 30 FREE L $(JY)JY[jy]E[jyEC]|2
earning.freeze 1 YN L $(JY)JY[jy]E[jyEC]|5
earning.wexpr 60 FREE L $(JY)JY[jy]E[jyEC]|3
Ì € i 2
eff.base.rates
[employee, eff.date]
$(JY)JY[jy]13[jefd]
Field Name Len Dat Typ J DPM Offset/Local/VAL
eff.date 8 DATE L jefd
eff.rate 8 RATE R $(JY)JY[jy]13[jefd]|1
eff.reason 10 FREE L PP.REASON $(JY)JY[jy]13[jefd]|2
eff.step 2 PINT L $(JY)JY[jy]13[jefd]|0
Ì € i 2
sec.jobs
[employee, sec.job.counter]
$(JY)JY[jy]SJ[jySC]
Field Name Len Dat Typ J DPM Offset/Local/VAL
sec.job.counter 2 INT R jySC
sec.job 10 FREE L PP.JOB $(JY)JY[jy]SJ[jySC]|0
sec.job.contract 8 FREE L PP.CONTRACT $(JY)JY[jy]SJ[jySC]|5
sec.job.dept 15 FREE L MIS.GL.DEPT $(JY)JY[jy]SJ[jySC]|2
sec.job.hrs.percent 6 DEC3 R $(JY)JY[jy]SJ[jySC]|3
sec.job.rate 8 RATE R $(JY)JY[jy]SJ[jySC]|1
sec.job.step 2 PINT L $(JY)JY[jy]SJ[jySC]|4
Ì € i 2
sec.eff.rates
[employee,sec.job.counter, sec.eff.date]
$(JY)JY[jy]SJ[jySC]SR[jefd]
Field Name Len Dat Typ J DPM Offset/Local/VAL
sec.eff.date 8 DATE L jefd
sec.eff.rate 8 RATE R $(JY)JY[jy]SJ[jySC]SR[jefd]|1
sec.eff.step 2 PINT L $(JY)JY[jy]SJ[jySC]SR[jefd]|0
Ì € i 2
skills
[employee, skill]
$(JY)JY[jy]4[gqk]
Field Name Len Dat Typ J DPM Offset/Local/VAL
skill 10 FREE L MIS.SKILL gqk
sk.ceu 5 DEC2 R $(JY)JY[jy]4[gqk]|3
sk.cmu 5 DEC2 R $(JY)JY[jy]4[gqk]|5
sk.comment 30 FREE L $(JY)JY[jy]4[gqk]|1
sk.effective.date 8 DATE L $(JY)JY[jy]4[gqk]|2
sk.expiration.date 8 DATE L $(JY)JY[jy]4[gqk]|4
sk.use 1 FREE L $(JY)JY[jy]4[gqk]|0
Ì € i 2
withholdings
[employee, whold]
$(JY)JY[jy]10[jdw]
Field Name Len Dat Typ J DPM Offset/Local/VAL
whold 8 PDEC L PP.WHOLD jdw
whold.account.number 14 FREE L $(JY)JY[jy]10[jdw]|1
whold.active 1 YN L $(JY)JY[jy]10[jdw]|0
whold.balance 8 MONEY R $(JY)JY[jy]10[jdw]|4
whold.bond.price 8 MONEY R $(JY)JY[jy]10[jdw]|5
whold.created.by.flex 1 YN L $(JY)JY[jy]10[jdw]|11
whold.employee.wexpr 60 FREE L $(JY)JY[jy]10[jdw]|7
whold.employer.expr 30 FREE L $(JY)JY[jy]10[jdw]|8
whold.employer.wexpr 60 FREE L $(JY)JY[jy]10[jdw]|9
whold.expressions 30 FREE L $(JY)JY[jy]10[jdw]|6
whold.from.date 8 DATE L $(JY)JY[jy]10[jdw]|2
whold.more.below 1 FREE L $(JY)JY[jy]10[jdw]|10
whold.thru.date 8 DATE L $(JY)JY[jy]10[jdw]|3
Ì € i 2
transactions
[employee.txn]
*(JY)JYTX[jy]
Field Name Len Dat Typ J DPM Offset/Local/VAL
employee.txn 42 URN L PP.PER jy
Ì € i 2
add.earn.txns
[employee.txn, atxn.earning,atxn.date,atxn.time]
*(JY)JYTX[jy]14[jde,jyAED,jyAET]
Field Name Len Dat Typ J DPM Offset/Local/VAL
atxn.earning 8 PDEC L PP.EARN jde
atxn.date 8 DATE L jyAED
atxn.time 5 TIME L jyAET
atxn.amount 8 SMONEY R *(JY)JYTX[jy]14[jde,jyAED,jyAET]|1
atxn.balance 8 SMONEY R *(JY)JYTX[jy]14[jde,jyAED,jyAET]|2
atxn.tc.pointer 8 URN L PP.PAY *(JY)JYTX[jy]14[jde,jyAED,jyAET]|3
atxn.type 1 FREE L *(JY)JYTX[jy]14[jde,jyAED,jyAET]|0
Ì € i 2
add.wholding.txns
[employee.txn, add.wtxn.whold,add.wtxn.date,add.wtxn.time]
*(JY)JYTX[jy]15[jdw,jyAWD,jyAWT]
Field Name Len Dat Typ J DPM Offset/Local/VAL
add.wtxn.whold 8 PDEC L PP.WHOLD jdw
add.wtxn.date 8 DATE L jyAWD
add.wtxn.time 5 TIME L jyAWT
add.wtxn.ee.amount 8 SMONEY R *(JY)JYTX[jy]15[jdw,jyAWD,jyAWT]|1
add.wtxn.ee.balance 8 SMONEY R *(JY)JYTX[jy]15[jdw,jyAWD,jyAWT]|3
add.wtxn.er.amount 8 SMONEY R *(JY)JYTX[jy]15[jdw,jyAWD,jyAWT]|2
add.wtxn.er.balance 8 SMONEY R *(JY)JYTX[jy]15[jdw,jyAWD,jyAWT]|4
add.wtxn.tc.pointer 8 URN L PP.PAY *(JY)JYTX[jy]15[jdw,jyAWD,jyAWT]|5
add.wtxn.type 1 FREE L *(JY)JYTX[jy]15[jdw,jyAWD,jyAWT]|0
Ì € i 2
audit.trail
[employee.txn, audit.date,audit.time]
*(JY)JYTX[jy]0[jyMD,jyMT]
Field Name Len Dat Typ J DPM Offset/Local/VAL
audit.date 8 DATE L jyMD
audit.time 5 TIME L jyMT
audit.address1 30 FREE L *(JY)JYTX[jy]0[jyMD,jyMT]5|0
audit.address2 30 FREE L *(JY)JYTX[jy]0[jyMD,jyMT]5|1
audit.adjusted.hire.date 8 DATE L *(JY)JYTX[jy]0[jyMD,jyMT]1|12
audit.base.rate 8 RATE R *(JY)JYTX[jy]0[jyMD,jyMT]7|7
audit.base.rate.date 8 DATE L *(JY)JYTX[jy]0[jyMD,jyMT]7|9
audit.base.rate.reason 10 FREE L PP.REASON *(JY)JYTX[jy]0[jyMD,jyMT]7|8
audit.being.paid 1 YN L *(JY)JYTX[jy]0[jyMD,jyMT]1|10
audit.benefit.contr.hours 10 SDEC3 R *(JY)JYTX[jy]0[jyMD,jyMT]1|18
audit.city 18 FREE L *(JY)JYTX[jy]0[jyMD,jyMT]5|2
audit.cobra.number 42 URN L PP.PER.COBRA *(JY)JYTX[jy]0[jyMD,jyMT]M1|6
audit.contract 8 FREE L PP.CONTRACT *(JY)JYTX[jy]0[jyMD,jyMT]1|17
audit.date.of.birth 10 BDATE L *(JY)JYTX[jy]0[jyMD,jyMT]0|11
audit.dd.proration.method 1 CHOICE L *(JY)JYTX[jy]0[jyMD,jyMT]7|25
audit.de6.wage.plan 1 CHOICE L *(JY)JYTX[jy]0[jyMD,jyMT]0|17
audit.deceased 1 YN L *(JY)JYTX[jy]0[jyMD,jyMT]7|23
audit.dept 15 FREE L MIS.GL.DEPT *(JY)JYTX[jy]0[jyMD,jyMT]1|3
audit.disability 1 YN L *(JY)JYTX[jy]0[jyMD,jyMT]M1|0
audit.eeoc 18 CHOICE L *(JY)JYTX[jy]0[jyMD,jyMT]0|13
audit.email.addr 40 FREE L *(JY)JYTX[jy]0[jyMD,jyMT]M1|9
audit.emergency.phone 18 PHONE L *(JY)JYTX[jy]0[jyMD,jyMT]0|10
audit.emp.user.mnemonic 10 FREE L MIS.USER *(JY)JYTX[jy]0[jyMD,jyMT]M1|12
audit.empl.type 5 FREE L PP.TYPE *(JY)JYTX[jy]0[jyMD,jyMT]1|0
audit.empl.type.date 8 DATE L *(JY)JYTX[jy]0[jyMD,jyMT]1|22
audit.evaluation.date 8 DATE L *(JY)JYTX[jy]0[jyMD,jyMT]1|16
audit.exclude.from.de6 1 YN L *(JY)JYTX[jy]0[jyMD,jyMT]0|16
audit.exempt 1 YN L *(JY)JYTX[jy]0[jyMD,jyMT]7|5
audit.fit.exemptions 2 INT R *(JY)JYTX[jy]0[jyMD,jyMT]7|4
audit.fit.tax.status 1 CHOICE L *(JY)JYTX[jy]0[jyMD,jyMT]7|3
audit.flsa.per.week.calc 1 YN L *(JY)JYTX[jy]0[jyMD,jyMT]0|15
audit.fmla.start 4 INT R *(JY)JYTX[jy]0[jyMD,jyMT]M1|13
audit.health.insurance 1 YN L *(JY)JYTX[jy]0[jyMD,jyMT]M1|3
audit.hire.date 8 DATE L *(JY)JYTX[jy]0[jyMD,jyMT]1|11
audit.home.phone 18 PHONE L *(JY)JYTX[jy]0[jyMD,jyMT]0|9
audit.hours.per.period 6 DEC3 R *(JY)JYTX[jy]0[jyMD,jyMT]1|6
audit.hrs.per.period.date 8 DATE L *(JY)JYTX[jy]0[jyMD,jyMT]1|23
audit.incomplete.pay.fld 1 YN L *(JY)JYTX[jy]0[jyMD,jyMT]7|19
audit.insurance.coverage 40 FREE L *(JY)JYTX[jy]0[jyMD,jyMT]7|20
audit.job.code 10 FREE L PP.JOB *(JY)JYTX[jy]0[jyMD,jyMT]1|2
audit.marital.status 10 FREE L MIS.MAR.STATUS *(JY)JYTX[jy]0[jyMD,jyMT]M1|4
audit.marital.status.date 8 DATE L *(JY)JYTX[jy]0[jyMD,jyMT]M1|5
audit.medicare.date 8 DATE L *(JY)JYTX[jy]0[jyMD,jyMT]M1|2
audit.name 26 NAME L *(JY)JYTX[jy]0[jyMD,jyMT]0|2
audit.next.review.date 8 DATE L *(JY)JYTX[jy]0[jyMD,jyMT]1|13
audit.next.review.reason 10 FREE L PP.REASON *(JY)JYTX[jy]0[jyMD,jyMT]1|14
audit.number 14 FREE L *(JY)JYTX[jy]0[jyMD,jyMT]0|4
audit.ont.vac.calc.thru 8 DATE L *(JY)JYTX[jy]0[jyMD,jyMT]7|22
audit.other.country 10 FREE L *(JY)JYTX[jy]0[jyMD,jyMT]5|6
audit.other.country.ch 6 CHOICE L *(JY)JYTX[jy]0[jyMD,jyMT]5|5
audit.outside.agency 1 YN L *(JY)JYTX[jy]0[jyMD,jyMT]0|14
audit.payroll 8 FREE L PP.PAYROLL *(JY)JYTX[jy]0[jyMD,jyMT]7|0
audit.pension 1 YN L *(JY)JYTX[jy]0[jyMD,jyMT]7|24
audit.pop.grp 8 FREE L PP.POPUL *(JY)JYTX[jy]0[jyMD,jyMT]M1|1
audit.position.date 8 DATE L *(JY)JYTX[jy]0[jyMD,jyMT]1|24
audit.position.number 18 FREE L PP.POS *(JY)JYTX[jy]0[jyMD,jyMT]1|1
audit.postal.code 10 FREE L *(JY)JYTX[jy]0[jyMD,jyMT]5|4
audit.qual.diff 8 RATE R *(JY)JYTX[jy]0[jyMD,jyMT]7|11
audit.reserved.position 18 FREE L PP.POS *(JY)JYTX[jy]0[jyMD,jyMT]1|25
audit.review.contr.hours 10 SDEC3 R *(JY)JYTX[jy]0[jyMD,jyMT]1|19
audit.roe.date 8 DATE L *(JY)JYTX[jy]0[jyMD,jyMT]1|21
audit.seniority.date 8 DATE L *(JY)JYTX[jy]0[jyMD,jyMT]1|15
audit.sex 1 CHOICE L *(JY)JYTX[jy]0[jyMD,jyMT]0|12
audit.shift 1 PINT R *(JY)JYTX[jy]0[jyMD,jyMT]1|4
audit.shift.date 8 DATE L *(JY)JYTX[jy]0[jyMD,jyMT]1|5
audit.si.number 12 FREE L *(JY)JYTX[jy]0[jyMD,jyMT]0|1
audit.sit.exemptions 2 INT R *(JY)JYTX[jy]0[jyMD,jyMT]7|2
audit.sit.tax.status 1 CHOICE L *(JY)JYTX[jy]0[jyMD,jyMT]7|1
audit.sort.name 26 NAME L *(JY)JYTX[jy]0[jyMD,jyMT]0|3
audit.ss.number 12 FREE L *(JY)JYTX[jy]0[jyMD,jyMT]0|1
audit.state 2 FREE L *(JY)JYTX[jy]0[jyMD,jyMT]5|3
audit.status 7 CHOICE L *(JY)JYTX[jy]0[jyMD,jyMT]1|7
audit.status.date 8 DATE L *(JY)JYTX[jy]0[jyMD,jyMT]1|8
audit.status.reason 10 FREE L PP.REASON *(JY)JYTX[jy]0[jyMD,jyMT]1|9
audit.statutory 1 YN L *(JY)JYTX[jy]0[jyMD,jyMT]7|26
audit.step 2 PINT R *(JY)JYTX[jy]0[jyMD,jyMT]7|6
audit.t4.country 10 FREE L *(JY)JYTX[jy]0[jyMD,jyMT]6|3
audit.t4.country.choice 5 CHOICE L *(JY)JYTX[jy]0[jyMD,jyMT]6|2
audit.t4.cpp.qpp.exempt 1 YN L *(JY)JYTX[jy]0[jyMD,jyMT]6|0
audit.t4.ei.exempt 1 YN L *(JY)JYTX[jy]0[jyMD,jyMT]6|1
audit.t4.employment.code 2 CHOICE L *(JY)JYTX[jy]0[jyMD,jyMT]6|4
audit.t4.stock.code 2 CHOICE L *(JY)JYTX[jy]0[jyMD,jyMT]6|5
audit.tax.year 4 YEAR L *(JY)JYTX[jy]0[jyMD,jyMT]7|21
audit.tc.hours.pro.elig 1 YN L *(JY)JYTX[jy]0[jyMD,jyMT]M1|10
audit.tc.hrs.pro.pri.pct 6 DEC3 R *(JY)JYTX[jy]0[jyMD,jyMT]M1|11
audit.td1.exemption 8 MONEY R *(JY)JYTX[jy]0[jyMD,jyMT]7|10
audit.td1.exemption.prov 8 MONEY R *(JY)JYTX[jy]0[jyMD,jyMT]7|27
audit.user 10 FREE L MIS.USER *(JY)JYTX[jy]0[jyMD,jyMT]
Ì € i 2
audit.benefit.balances
[employee.txn,audit.date,audit.time, audit.benefit]
*(JY)JYTX[jy]0[jyMD,jyMT]9[jde]
Field Name Len Dat Typ J DPM Offset/Local/VAL
audit.benefit 8 PDEC R PP.BENEFIT jde
audit.benefit.accrued.bal 9 SDEC3 R *(JY)JYTX[jy]0[jyMD,jyMT]9[jde]|3
audit.benefit.avail.bal 9 SDEC3 R *(JY)JYTX[jy]0[jyMD,jyMT]9[jde]|2
audit.benefit.edit.reason 10 FREE L PP.REASON *(JY)JYTX[jy]0[jyMD,jyMT]9[jde]|8
audit.benefit.freeze 1 YN L *(JY)JYTX[jy]0[jyMD,jyMT]9[jde]|5
audit.benefit.freeze.date 8 DATE L *(JY)JYTX[jy]0[jyMD,jyMT]9[jde]|6
audit.benefit.frz.con.hrs 8 DEC3 R *(JY)JYTX[jy]0[jyMD,jyMT]9[jde]|7
audit.benefit.occur.yr 4 YEAR L *(JY)JYTX[jy]0[jyMD,jyMT]9[jde]|10
audit.benefit.occurance 3 PINT R *(JY)JYTX[jy]0[jyMD,jyMT]9[jde]|9
audit.benefit.plan 8 FREE L *(JY)JYTX[jy]0[jyMD,jyMT]9[jde]|1
audit.benefit.update.gl 1 YN L *(JY)JYTX[jy]0[jyMD,jyMT]9[jde]|4
Ì € i 2
audit.cust.def.queries
[employee.txn,audit.date,audit.time, audit.cd.query]
*(JY)JYTX[jy]0[jyMD,jyMT]CD[ggv]
Field Name Len Dat Typ J DPM Offset/Local/VAL
audit.cd.query 10 FREE L MIS.QUERY ggv
audit.cd.response 75 QRY.RESP L *(JY)JYTX[jy]0[jyMD,jyMT]CD[ggv]|0
audit.cd.yn.comment 75 FREE L *(JY)JYTX[jy]0[jyMD,jyMT]CD[ggv]|5
Ì € i 2
audit.cust.def.mult
[employee.txn,audit.date,audit.time,audit.cd.query, audit.cdm.seq.no]
*(JY)JYTX[jy]0[jyMD,jyMT]CD[ggv]M[ggvN]
Field Name Len Dat Typ J DPM Offset/Local/VAL
audit.cdm.seq.no 3 PINT R ggvN
audit.cdm.response 75 QRY.RESP L *(JY)JYTX[jy]0[jyMD,jyMT]CD[ggv]M[ggvN]|0
Ì € i 2
audit.dd.proration
[employee.txn,audit.date,audit.time, audit.dd.pro.counter]
*(JY)JYTX[jy]0[jyMD,jyMT]2[mpC]
Field Name Len Dat Typ J DPM Offset/Local/VAL
audit.dd.pro.counter 2 PINT R mpC
audit.dd.pro.account.num 17 FREE L *(JY)JYTX[jy]0[jyMD,jyMT]2[mpC]|2
audit.dd.pro.account.type 1 CHOICE L *(JY)JYTX[jy]0[jyMD,jyMT]2[mpC]|3
audit.dd.pro.bank 17 FREE L PP.BANK *(JY)JYTX[jy]0[jyMD,jyMT]2[mpC]|1
audit.dd.pro.note.account 17 FREE L *(JY)JYTX[jy]0[jyMD,jyMT]2[mpC]|6
audit.dd.pro.note.bank 17 FREE L PP.BANK *(JY)JYTX[jy]0[jyMD,jyMT]2[mpC]|5
audit.dd.pro.note.date 8 DATE L *(JY)JYTX[jy]0[jyMD,jyMT]2[mpC]|8
audit.dd.pro.note.type 1 CHOICE L *(JY)JYTX[jy]0[jyMD,jyMT]2[mpC]|7
audit.dd.pro.type 7 CHOICE L *(JY)JYTX[jy]0[jyMD,jyMT]2[mpC]|0
audit.dd.pro.value 10 FREE L *(JY)JYTX[jy]0[jyMD,jyMT]2[mpC]|4
Ì € i 2
audit.dependents
[employee.txn,audit.date,audit.time, audit.dp.number]
*(JY)JYTX[jy]0[jyMD,jyMT]14[jyDP]
Field Name Len Dat Typ J DPM Offset/Local/VAL
audit.dp.number 2 PINT R jyDP
audit.dp.active 1 YN L *(JY)JYTX[jy]0[jyMD,jyMT]14[jyDP]|5
audit.dp.address1 30 FREE L *(JY)JYTX[jy]0[jyMD,jyMT]14[jyDP]0|0
audit.dp.address2 30 FREE L *(JY)JYTX[jy]0[jyMD,jyMT]14[jyDP]0|1
audit.dp.birthdate 10 BDATE L *(JY)JYTX[jy]0[jyMD,jyMT]14[jyDP]|1
audit.dp.city 18 FREE L *(JY)JYTX[jy]0[jyMD,jyMT]14[jyDP]0|2
audit.dp.cobra.number 42 URN L PP.PER.COBRA *(JY)JYTX[jy]0[jyMD,jyMT]14[jyDP]|11
audit.dp.email.addr 40 FREE L *(JY)JYTX[jy]0[jyMD,jyMT]14[jyDP]|14
audit.dp.emergency.phone 18 PHONE L *(JY)JYTX[jy]0[jyMD,jyMT]14[jyDP]|8
audit.dp.home.phone 18 PHONE L *(JY)JYTX[jy]0[jyMD,jyMT]14[jyDP]|7
audit.dp.marital.status 10 FREE L MIS.MAR.STATUS *(JY)JYTX[jy]0[jyMD,jyMT]14[jyDP]|9
audit.dp.marital.sts.date 8 DATE L *(JY)JYTX[jy]0[jyMD,jyMT]14[jyDP]|10
audit.dp.medicare.date 8 DATE L *(JY)JYTX[jy]0[jyMD,jyMT]14[jyDP]|12
audit.dp.name 26 NAME L *(JY)JYTX[jy]0[jyMD,jyMT]14[jyDP]|0
audit.dp.other.country 10 FREE L *(JY)JYTX[jy]0[jyMD,jyMT]14[jyDP]0|6
audit.dp.other.country.ch 6 FREE L *(JY)JYTX[jy]0[jyMD,jyMT]14[jyDP]0|5
audit.dp.postal.code 10 FREE L *(JY)JYTX[jy]0[jyMD,jyMT]14[jyDP]0|4
audit.dp.relationship 10 FREE L MIS.RELAT *(JY)JYTX[jy]0[jyMD,jyMT]14[jyDP]|2
audit.dp.si.number 12 FREE L *(JY)JYTX[jy]0[jyMD,jyMT]14[jyDP]|3
audit.dp.sort.name 26 NAME L *(JY)JYTX[jy]0[jyMD,jyMT]14[jyDP]|4
audit.dp.ss.number 12 FREE L *(JY)JYTX[jy]0[jyMD,jyMT]14[jyDP]|3
audit.dp.state 2 FREE L *(JY)JYTX[jy]0[jyMD,jyMT]14[jyDP]0|3
audit.dp.student.thru.dt 8 DATE L *(JY)JYTX[jy]0[jyMD,jyMT]14[jyDP]|6
Ì € i 2
audit.earnings
[employee.txn,audit.date,audit.time, audit.earning.counter]
*(JY)JYTX[jy]0[jyMD,jyMT]12[jyEC]
Field Name Len Dat Typ J DPM Offset/Local/VAL
audit.earning.counter 2 PINT R jyEC
audit.earning 8 PDEC L PP.EARN *(JY)JYTX[jy]0[jyMD,jyMT]12[jyEC]|0
audit.earning.active 1 YN L *(JY)JYTX[jy]0[jyMD,jyMT]12[jyEC]|1
audit.earning.created.flx 1 YN L *(JY)JYTX[jy]0[jyMD,jyMT]12[jyEC]|4
audit.earning.expression 30 FREE L *(JY)JYTX[jy]0[jyMD,jyMT]12[jyEC]|2
audit.earning.freeze 1 YN L *(JY)JYTX[jy]0[jyMD,jyMT]12[jyEC]|5
audit.earning.wexpr 60 FREE L *(JY)JYTX[jy]0[jyMD,jyMT]12[jyEC]|3
Ì € i 2
audit.eff.base.rates
[employee.txn,audit.date,audit.time, audit.eff.date]
*(JY)JYTX[jy]0[jyMD,jyMT]13[jefd]
Field Name Len Dat Typ J DPM Offset/Local/VAL
audit.eff.date 8 DATE L jefd
audit.eff.rate 8 RATE R *(JY)JYTX[jy]0[jyMD,jyMT]13[jefd]|1
audit.eff.reason 10 FREE L PP.REASON *(JY)JYTX[jy]0[jyMD,jyMT]13[jefd]|2
audit.eff.step 2 PINT R *(JY)JYTX[jy]0[jyMD,jyMT]13[jefd]|0
Ì € i 2
audit.sec.jobs
[employee.txn,audit.date,audit.time, audit.sec.job.counter]
*(JY)JYTX[jy]0[jyMD,jyMT]8[jySC]
Field Name Len Dat Typ J DPM Offset/Local/VAL
audit.sec.job.counter 2 PINT R jySC
audit.sec.job 10 FREE L PP.JOB *(JY)JYTX[jy]0[jyMD,jyMT]8[jySC]|0
audit.sec.job.contract 8 FREE L PP.CONTRACT *(JY)JYTX[jy]0[jyMD,jyMT]8[jySC]|5
audit.sec.job.dept 15 FREE L MIS.GL.DEPT *(JY)JYTX[jy]0[jyMD,jyMT]8[jySC]|2
audit.sec.job.hrs.percent 6 DEC3 R *(JY)JYTX[jy]0[jyMD,jyMT]8[jySC]|3
audit.sec.job.rate 8 RATE R *(JY)JYTX[jy]0[jyMD,jyMT]8[jySC]|1
audit.sec.job.step 2 PINT R *(JY)JYTX[jy]0[jyMD,jyMT]8[jySC]|4
Ì € i 2
audit.skills
[employee.txn,audit.date,audit.time, audit.skill]
*(JY)JYTX[jy]0[jyMD,jyMT]4[gqk]
Field Name Len Dat Typ J DPM Offset/Local/VAL
audit.skill 10 FREE L MIS.SKILL gqk
audit.sk.ceu 5 DEC2 R *(JY)JYTX[jy]0[jyMD,jyMT]4[gqk]|3
audit.sk.cmu 5 DEC2 R *(JY)JYTX[jy]0[jyMD,jyMT]4[gqk]|5
audit.sk.comment 30 FREE L *(JY)JYTX[jy]0[jyMD,jyMT]4[gqk]|1
audit.sk.effective.date 8 DATE L *(JY)JYTX[jy]0[jyMD,jyMT]4[gqk]|2
audit.sk.expiration.date 8 DATE L *(JY)JYTX[jy]0[jyMD,jyMT]4[gqk]|4
audit.sk.use 1 YN L *(JY)JYTX[jy]0[jyMD,jyMT]4[gqk]|0
Ì € i 2
audit.trail.mult.values
[employee.txn,audit.date,audit.time, audit.subscript.1,audit.subscript.2]
*(JY)JYTX[jy]0[jyMD,jyMT,jyMS,jyMSS]
Field Name Len Dat Typ J DPM Offset/Local/VAL
audit.subscript.1 2 FREE L jyMS
audit.subscript.2 50 FREE L jyMSS
audit.value.2 200 FREE L *(JY)JYTX[jy]0[jyMD,jyMT,jyMS,jyMSS]
audit.value.src 1 CHOICE L *(JY)JYTX[jy]0[jyMD,jyMT,jyMS,jyMSS]S|0
Ì € i 2
audit.trail.mult.values.4
[employee.txn,audit.date,audit.time,audit.subscript.1,audit.subscript.2, audit.subscript.3,aud
*(JY)JYTX[jy]0[jyMD,jyMT,jyMS,jyMSS,jyMS3,jyMS4]
Field Name Len Dat Typ J DPM Offset/Local/VAL
audit.subscript.3 50 FREE L jyMS3
audit.subscript.4 50 FREE L jyMS4
audit.value.4 200 FREE L *(JY)JYTX[jy]0[jyMD,jyMT,jyMS,jyMSS,jyMS3,jyMS4]
Ì € i 2
audit.trail.values
[employee.txn,audit.date,audit.time, audit.subscript]
*(JY)JYTX[jy]0[jyMD,jyMT,jyMS]
Field Name Len Dat Typ J DPM Offset/Local/VAL
audit.subscript 55 FREE L jyMS
audit.value 200 FREE L *(JY)JYTX[jy]0[jyMD,jyMT,jyMS]
Ì € i 2
audit.withholdings
[employee.txn,audit.date,audit.time, audit.whold]
*(JY)JYTX[jy]0[jyMD,jyMT]10[jdw]
Field Name Len Dat Typ J DPM Offset/Local/VAL
audit.whold 8 PDEC L PP.WHOLD jdw
audit.whold.account.num 14 FREE L *(JY)JYTX[jy]0[jyMD,jyMT]10[jdw]|1
audit.whold.active 1 YN L *(JY)JYTX[jy]0[jyMD,jyMT]10[jdw]|0
audit.whold.balance 8 MONEY R *(JY)JYTX[jy]0[jyMD,jyMT]10[jdw]|4
audit.whold.bond.price 8 MONEY R *(JY)JYTX[jy]0[jyMD,jyMT]10[jdw]|5
audit.whold.created.flex 1 YN L *(JY)JYTX[jy]0[jyMD,jyMT]10[jdw]|11
audit.whold.emplee.wexpr 60 FREE L *(JY)JYTX[jy]0[jyMD,jyMT]10[jdw]|7
audit.whold.empler.expr 30 FREE L *(JY)JYTX[jy]0[jyMD,jyMT]10[jdw]|8
audit.whold.empler.wexpr 60 FREE L *(JY)JYTX[jy]0[jyMD,jyMT]10[jdw]|9
audit.whold.expressions 30 FREE L *(JY)JYTX[jy]0[jyMD,jyMT]10[jdw]|6
audit.whold.from.date 8 DATE L *(JY)JYTX[jy]0[jyMD,jyMT]10[jdw]|2
audit.whold.more.below 1 FREE L *(JY)JYTX[jy]0[jyMD,jyMT]10[jdw]|10
audit.whold.thru.date 8 DATE L *(JY)JYTX[jy]0[jyMD,jyMT]10[jdw]|3
Ì € i 2
benefit.transactions
[employee.txn, btxn.earning,btxn.date,btxn.time]
*(JY)JYTX[jy]11[jde,jyBD,jyBT]
Field Name Len Dat Typ J DPM Offset/Local/VAL
btxn.earning 8 PDEC L PP.EARN jde
btxn.date 8 DATE L jyBD
btxn.time 5 TIME L jyBT
btxn.accrued.balance 8 SDEC3 R *(JY)JYTX[jy]11[jde,jyBD,jyBT]|9
btxn.adjustment 8 SDEC3 R *(JY)JYTX[jy]11[jde,jyBD,jyBT]|7
btxn.avail.balance 8 SDEC3 R *(JY)JYTX[jy]11[jde,jyBD,jyBT]|8
btxn.award 8 SDEC3 R *(JY)JYTX[jy]11[jde,jyBD,jyBT]|5
btxn.benefit.freeze 1 YN L *(JY)JYTX[jy]11[jde,jyBD,jyBT]|12
btxn.earned 8 SDEC3 R *(JY)JYTX[jy]11[jde,jyBD,jyBT]|3
btxn.earned.print 8 SDEC3 R VAL=(@btxn.earned+@btxn.award)
btxn.edit.reason 10 FREE L PP.REASON *(JY)JYTX[jy]11[jde,jyBD,jyBT]|13
btxn.hour.basis 8 SDEC3 R *(JY)JYTX[jy]11[jde,jyBD,jyBT]|2
btxn.occurance 3 PINT R *(JY)JYTX[jy]11[jde,jyBD,jyBT]|14
btxn.plan 8 FREE L *(JY)JYTX[jy]11[jde,jyBD,jyBT]|0
btxn.taken 8 SDEC3 R *(JY)JYTX[jy]11[jde,jyBD,jyBT]|4
btxn.tc.pointer 8 URN L PP.PAY *(JY)JYTX[jy]11[jde,jyBD,jyBT]|10
btxn.transfer 8 SDEC3 R *(JY)JYTX[jy]11[jde,jyBD,jyBT]|6
btxn.type 1 CHOICE L *(JY)JYTX[jy]11[jde,jyBD,jyBT]|1
btxn.zero.avail.first 8 SDEC3 R *(JY)JYTX[jy]11[jde,jyBD,jyBT]|11
Ì € i 2
contr.hrs.transactions
[employee.txn, ctxn.date,ctxn.time]
*(JY)JYTX[jy]13[jyCD,jyCT]
Field Name Len Dat Typ J DPM Offset/Local/VAL
ctxn.date 8 DATE L jyCD
ctxn.time 5 TIME L jyCT
ctxn.ben.hrs 8 SDEC3 R *(JY)JYTX[jy]13[jyCD,jyCT]|1
ctxn.ben.hrs.balance 10 SDEC3 R *(JY)JYTX[jy]13[jyCD,jyCT]|2
ctxn.rvw.hrs 8 SDEC3 R *(JY)JYTX[jy]13[jyCD,jyCT]|3
ctxn.rvw.hrs.balance 10 SDEC3 R *(JY)JYTX[jy]13[jyCD,jyCT]|4
ctxn.type 1 CHOICE L *(JY)JYTX[jy]13[jyCD,jyCT]|0
Ì € i 2
whold.transactions
[employee.txn, wtxn.whold,wtxn.date,wtxn.time]
*(JY)JYTX[jy]12[jdw,jyWD,jyWT]
Field Name Len Dat Typ J DPM Offset/Local/VAL
wtxn.whold 8 PDEC L PP.WHOLD jdw
wtxn.date 8 DATE L jyWD
wtxn.time 5 TIME L jyWT
wtxn.add.amount 8 SMONEY R VAL=(@wtxn.whold.amount+@wtxn.manual.amount)
wtxn.balance 8 SMONEY R *(JY)JYTX[jy]12[jdw,jyWD,jyWT]|3
wtxn.bond.amount.pur 8 SMONEY R *(JY)JYTX[jy]12[jdw,jyWD,jyWT]|5
wtxn.bond.num.pur 4 SINT R *(JY)JYTX[jy]12[jdw,jyWD,jyWT]|4
wtxn.manual.amount 8 SMONEY R *(JY)JYTX[jy]12[jdw,jyWD,jyWT]|2
wtxn.sub.amount 8 SMONEY R VAL=(@wtxn.manual.amount-@wtxn.whold.amount)
wtxn.tc.pointer 8 URN L PP.PAY *(JY)JYTX[jy]12[jdw,jyWD,jyWT]|6
wtxn.type 1 CHOICE L *(JY)JYTX[jy]12[jdw,jyWD,jyWT]|0
wtxn.whold.amount 8 SMONEY R *(JY)JYTX[jy]12[jdw,jyWD,jyWT]|1
Ì i 2
web.activity.queue
[wbq.date,wbq.emp.urn,wbq.form.urn]
*(JY)JY.WBQ[wbqDT,jy,wbfr]
Field Name Len Dat Typ J DPM Offset/Local/VAL
wbq.date 8 DATE L wbqDT
wbq.emp.urn 42 URN L PP.PER jy
wbq.form.urn 10 URN L wbfr
wbq.time 4 HHMM L *(JY)JY.WBQ[wbqDT,jy,wbfr]|0
Ì i 2
web.form.req
[wf.urn]
*(JY)JY.WBFR[wbfr]
Field Name Len Dat Typ J DPM Offset/Local/VAL
wf.urn 10 URN L wbfr
wf.address1 30 FREE L *(JY)JY.WBFR[wbfr]AD|0
wf.address2 30 FREE L *(JY)JY.WBFR[wbfr]AD|1
wf.city 18 FREE L *(JY)JY.WBFR[wbfr]AD|2
wf.date.of.birth 10 BDATE L *(JY)JY.WBFR[wbfr]E|3
wf.emergency.phone 18 PHONE L *(JY)JY.WBFR[wbfr]E|2
wf.emp.urn 42 URN L PP.PER *(JY)JY.WBFR[wbfr]|0
wf.home.phone 18 PHONE L *(JY)JY.WBFR[wbfr]E|1
wf.name 26 FREE L *(JY)JY.WBFR[wbfr]E|0
wf.postal.code 10 FREE L *(JY)JY.WBFR[wbfr]AD|4
wf.state 2 FREE L *(JY)JY.WBFR[wbfr]AD|3
wf.status 10 CHOICE L *(JY)JY.WBFR[wbfr]|2
wf.status.time 10 PINT R *(JY)JY.WBFR[wbfr]|4
wf.status.user 10 FREE L MIS.USER *(JY)JY.WBFR[wbfr]|3
wf.submit.secs 10 PINT R *(JY)JY.WBFR[wbfr]|1
Ì € i 2
web.form.req.other.data
[wf.urn, wf.other.txt.q]
*(JY)JY.WBFR[wbfr]OT[wbfOQ]
Field Name Len Dat Typ J DPM Offset/Local/VAL
wf.other.txt.q 3 URN L wbfOQ
wf.other.txt 60 TEXT L *(JY)JY.WBFR[wbfr]OT[wbfOQ]
Index Files Subscripts/Physical Base
activity.x [audit.date,employee]
?(JY)JYA[jyMD,jy]
add.earn.txn.x [atxn.date,atxn.earning,atxn.time,employee.txn]
?(JY)JYAEX[jyAED,jde,jyAET,jy]
add.whold.txn.x [add.wtxn.date,add.wtxn.whold,add.wtxn.time,employee.txn]
?(J)JYAWX[jyAWD,jdw,jyAWT,jy]
balances.activity [wtxn.date,wtxn.whold,wtxn.time,employee.txn]
?(JY)JYBX[jyWD,jdw,jyWT,jy]
cobra.name.x [sort.name,cobra.number]
?(JY)JYCN[jySN,jycb]
contract.name.x [contract,sort.name,employee]
?(JY)JYUN[jdc,jySN,jy]
dept.name.x [dept,sort.name,employee]
?(JY)JYDN[gd,jySN,jy]
ee.dt.letter.x [employee,print.date,letter,printing]
?(JY)JYEL[jy,jllPD,jllt,jllID]
employee.x [employee]
?(JY)JYX[jy]
file.x [activity.date,employee]
?(JY)JYC[jyAD,jy]
id.x [id,employee]
?(JY)JYI[jyI,jy]
name.x [sort.name,employee]
?(JY)JYN[jySN,jy]
number.x [number,employee]
?(JY)JYR[jyN,jy]
payroll.dept.name.x [payroll,dept,sort.name,employee]
?(JY)JYPDN[jdp,gd,jySN,jy]
payroll.dept.x [payroll,dept,employee]
?(JY)JYPD[jdp,gd,jy]
position.x [position.number,sort.name,employee]
?(JY)JYPO[jdr,jySN,jy]
postal.code.x [postal.country,postal.code,sort.name,employee]
?(JY)JYPX[pcnty,jyPC,jySN,jy]
reserved.pos.x [reserved.position,sort.name,employee]
?(JY)JYRPO[jdr,jySN,jy]
ss.x [ss.number] = employee
?(JY)JYS[jySS]
tax.whold.x [tax.year,payroll,whold,sort.name,employee]
?(JY)JYTW[jyTY,jdp,jdw,jySN,jy]
web.form.status.x [wf.status,wf.emp.urn,wf.urn]
?(JY)JY.WBS[wbfrS,jy,wbfr]
|
|
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |